create view vLegacySecurityRoleRef as
SELECT     'CustomerLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'BillingLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'CashARLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'EventsLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'OrdersLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'ReferralLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'CertificationLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'FundraisingLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'ServiceCentralLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b
UNION
SELECT     'ExpoLevel' + CAST(b.LevelCode AS varchar) AS Role
FROM         dbo.LegacySecurityLevelRef AS b

GO